1 <?php
2 session_start(); // Use session variable on this page. This function must put on the top of page.
3 if(!isset($_SESSION['username']) || $_SESSION['usertype'] !='admin'){ // if session variable "username" does not exist.
4 header("location:index.php?msg=Please%20login%20to%20access%20admin%20area%20!"); // Re-direct to index.php
5 }
6 else
7 {
8 include_once "db.php";
9 error_reporting (E_ALL ^ E_NOTICE);
10
11 ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
12 "http://www.w3.org/TR/html4/loose.dtd">
13 <html>
14 <head>
15 <title>Welcome to Stock Management System !</title>
16 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
17 <link rel="stylesheet" href="css/validationEngine.jquery.css" type="text/css" media="screen" title="no title" charset="utf-8" />
18 <link rel="stylesheet" href="css/template.css" type="text/css" media="screen" title="no title" charset="utf-8" />
19 <script src="js/jquery.min.js" type="text/javascript"></script>
20
21 <script type="text/javascript" src="jquery.date_input.js"></script>
22 <link rel="stylesheet" href="date_input.css" type="text/css">
23 <script type="text/javascript">$(function() {
24 $("#from_sales_date").date_input();
25 $("#to_sales_date").date_input();
26 $("#from_purchase_date").date_input();
27 $("#to_purchase_date").date_input();
28 $("#from_sales_purchase_date").date_input();
29 $("#to_sales_purchase_date").date_input();
30 $("#from_stock_sales_date").date_input();
31 $("#to_stock_sales_date").date_input();
32
33 });
34
35 function sales_report_fn()
36 {
37 window.open("sales_report.php?from_sales_date="+$('#from_sales_date').val()+"&to_sales_date="+$('#to_sales_date').val(),"myNewWinsr","width=620,height=800,toolbar=0,menubar=no,status=no,resizable=yes,location=no,directories=no,scrollbars=yes");
38
39 }
40 function purchase_report_fn()
41 {
42 window.open("purchase_report.php?from_purchase_date="+$('#from_purchase_date').val()+"&to_purchase_date="+$('#to_purchase_date').val(),"myNewWinsr","width=620,height=800,toolbar=0,menubar=no,status=no,resizable=yes,location=no,directories=no,scrollbars=yes");
43
44 }
45
46 function sales_purchase_report_fn()
47 {
48 window.open("all_report.php?from_sales_purchase_date="+$('#from_sales_purchase_date').val()+"&to_sales_purchase_date="+$('#to_sales_purchase_date').val(),"myNewWinsr","width=620,height=800,toolbar=0,menubar=no,status=no,resizable=yes,location=no,directories=no,scrollbars=yes");
49
50 }
51
52 function stock_sales_report_fn()
53 {
54 window.open("sales_stock_report.php?from_stock_sales_date="+$('#from_stock_sales_date').val()+"&to_stock_sales_date="+$('#to_stock_sales_date').val(),"myNewWinsr","width=620,height=800,toolbar=0,menubar=no,status=no,resizable=yes,location=no,directories=no,scrollbars=yes");
55
56 }
57
58 </script>
59
60
61
62 <script src="js/jquery.validationEngine-en.js" type="text/javascript"></script>
63 <script src="js/jquery.validationEngine.js" type="text/javascript"></script>
64 <script src="js/jquery.hotkeys-0.7.9.js"></script>
65 <!-- AJAX SUCCESS TEST FONCTION
66 <script>function callSuccessFunction(){alert("success executed")}
67 function callFailFunction(){alert("fail executed")}
68 </script>
69 -->
70
71 <script>
72
73
74
75
76
77 $(document).ready(function() {
78 // SUCCESS AJAX CALL, replace "success: false," by: success : function() { callSuccessFunction() },
79 $("#name").focus();
80 $("#form1").validationEngine(),
81
82 jQuery(document).bind('keydown', 'Ctrl+s',function() {
83 $('#form1').submit();
84 return false;
85 });
86
87 jQuery(document).bind('keydown', 'Ctrl+r',function() {
88 $('#form1').reset();
89 return false;
90 });
91 jQuery(document).bind('keydown', 'Ctrl+a',function() {
92 window.location = "addstock.php";
93 return false;
94 });
95 jQuery(document).bind('keydown', 'Ctrl+0',function() {
96 window.location = "admin.php";
97 return false;
98 });
99 jQuery(document).bind('keydown', 'Ctrl+1',function() {
100 window.location = "add_purchase.php";
101 return false;
102 });
103 jQuery(document).bind('keydown', 'Ctrl+2',function() {
104 window.location = "add_stock_sales.php";
105 return false;
106 });
107 jQuery(document).bind('keydown', 'Ctrl+3',function() {
108 window.location = "add_stock_details.php";
109 return false;
110 });
111 jQuery(document).bind('keydown', 'Ctrl+4',function() {
112 window.location = "add_category.php";
113 return false;
114 });
115 jQuery(document).bind('keydown', 'Ctrl+5',function() {
116 window.location = "add_supplier_details.php";
117 return false;
118 });
119 jQuery(document).bind('keydown', 'Ctrl+6',function() {
120 window.location = "add_customer_details.php";
121 return false;
122 });
123 jQuery(document).bind('keydown', 'Ctrl+7',function() {
124 window.location = "view_stock_entries.php";
125 return false;
126 });
127 jQuery(document).bind('keydown', 'Ctrl+8',function() {
128 window.location = "view_stock_sales.php";
129 return false;
130 });
131 jQuery(document).bind('keydown', 'Ctrl+9',function() {
132 window.location = "view_stock_details.php";
133 return false;
134 });
135 //$.validationEngine.loadValidation("#date")
136 //alert($("#formID").validationEngine({returnIsValid:true}))
137 //$.validationEngine.buildPrompt("#date","This is an example","error") // Exterior prompt build example // input prompt close example
138 //$.validationEngine.closePrompt(".formError",true) // CLOSE ALL OPEN PROMPTS
139 });
140 </script>
141 <style type="text/css">
142 <!--
143 body {
144 margin-left: 0px;
145 margin-top: 0px;
146 margin-right: 0px;
147 margin-bottom: 0px;
148 background-color: #FFFFFF;
149 }
150
151 *{
152 padding: 0px;
153 margin: 0px;
154 }
155 #vertmenu {
156 font-family: Verdana, Arial, Helvetica, sans-serif;
157 font-size: 100%;
158 width: 160px;
159 padding: 0px;
160 margin: 0px;
161 }
162
163 #vertmenu h1 {
164 display: block;
165 background-color:#FF9900;
166 font-size: 90%;
167 padding: 3px 0 5px 3px;
168 border: 1px solid #000000;
169 color: #333333;
170 margin: 0px;
171 width:159px;
172 }
173
174 #vertmenu ul {
175 list-style: none;
176 margin: 0px;
177 padding: 0px;
178 border: none;
179 }
180 #vertmenu ul li {
181 margin: 0px;
182 padding: 0px;
183 }
184 #vertmenu ul li a {
185 font-size: 80%;
186 display: block;
187 border-bottom: 1px dashed #C39C4E;
188 padding: 5px 0px 2px 4px;
189 text-decoration: none;
190 color: #666666;
191 width:160px;
192 }
193
194 #vertmenu ul li a:hover, #vertmenu ul li a:focus {
195 color: #000000;
196 background-color: #eeeeee;
197 }
198 .style1 {color: #000000}
199
200 -->
201 </style>
202 </head>
203
204 <body>
205 <table width="100%" border="0" cellspacing="0" cellpadding="0">
206 <tr>
207 <td align="center" valign="top"><table width="960" border="0" cellspacing="0" cellpadding="0">
208 <tr>
209 <td><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
210 <tr>
211 <td height="90" align="left" valign="top"><img src="images/topbanner.jpg" width="960" height="82"></td>
212 </tr>
213 <tr>
214 <td height="500" align="left" valign="top"><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
215 <tr>
216 <td width="130" align="left" valign="top">
217
218 <br>
219
220 <strong>Welcome <font color="#3399FF"><?php echo $_SESSION['username']; ?> !</font></strong><br> <br>
221 <table width="100%" border="0" cellspacing="0" cellpadding="0">
222 <tr>
223 <td align="center"><a href="admin.php"><img src="images/home.png" width="130" height="99" border="0"></a></td>
224 </tr>
225 <tr>
226 <td align="center"> </td>
227 </tr>
228 <tr>
229 <td align="center"><a href="add_purchase.php"><img src="images/purchase.png" width="130" height="124" border="0"></a></td>
230 </tr>
231 <tr>
232 <td align="center"> </td>
233 </tr>
234 <tr>
235 <td align="center"><a href="add_stock_sales.php"><img src="images/sales.png" width="146" height="111" border="0"></a></td>
236 </tr>
237 <tr>
238 <td align="center"> </td>
239 </tr>
240 <tr>
241 <td align="center"><a href="report.php"><img src="images/reports.png" width="131" height="142" border="0"></a></td>
242 </tr>
243 <tr>
244 <td align="center"> </td>
245 </tr>
246 <tr>
247 <td align="center"> </td>
248 </tr>
249 <tr>
250 <td align="center"> </td>
251 </tr>
252 </table>
253
254
255
256
257
258 </td>
259 <td height="414" align="center" valign="top">
260 <table width="100%" border="0" cellspacing="0" cellpadding="0">
261 <tr>
262 <td><a href="add_stock_details.php"><img src="images/addstockdetails.png" width="67" height="62" border="0"></a></td>
263 <td><a href="add_supplier_details.php"><img src="images/supplier.png" width="67" height="54" border="0"></a></td>
264 <td><a href="add_customer_details.php"><img src="images/customer.png" width="67" height="54" border="0"></a></td>
265 <td><a href="add_category.php"><img src="images/categories.png" width="67" height="54" border="0"></a></td>
266 <td><a href="view_stock_sales.php"><img src="images/vsales.png" width="67" height="54" border="0"></a></td>
267 <td><a href="view_stock_entries.php"><img src="images/vpurchase.png" width="67" height="54" border="0"></a></td>
268 <td><a href="view_stock_details.php"><img src="images/stockdetails.png" width="67" height="54" border="0"></a></td>
269 <td><a href="view_stock_availability.php"><img src="images/savail.png" width="67" height="54" border="0"></a></td>
270 <td align="left" valign="top"><a href="view_customer_details.php"><img src="images/customers.png" width="94" height="22" border="0"></a><br> <a href="view_supplier_details.php"><img src="images/suppliers.png" width="94" height="22" border="0"></a><br>
271 <a href="view_payments.php"><img src="images/payments.png" width="94" height="22" border="0"></a></td>
272 <td align="left" valign="top"><a href="view_stock_sales_payments.php"><img src="images/outstanding.png" width="94" height="22" border="0"></a><br> <a href="view_stock_entries_payments.php"><img src="images/pendings.png" width="94" height="22" border="0"></a><br>
273 <a href="logout.php"><img src="images/logout.png" width="94" height="22" border="0"></a></td>
274 </tr>
275 </table>
276
277 <br>
278 <br>
279 <strong>Reports</strong><br>
280 <br>
281 <table width="600" border="0" cellspacing="0" cellpadding="0">
282 <tr>
283 <form action="sales_report.php" method="post" name="sales_report" id="sales_report" target="myNewWinsr">
284 <td><strong>Sales Report </strong></td>
285 <td>From</td>
286 <td><input name="from_sales_date" type="text" id="from_sales_date" style="width:80px;"></td>
287 <td>To</td>
288 <td><input name="to_sales_date" type="text" id="to_sales_date" style="width:80px;"></td>
289 <td><input name="submit" type="button" value="Show" onClick='sales_report_fn();'></td>
290 </form>
291 </tr>
292 <tr>
293 <td> </td>
294 <td> </td>
295 <td> </td>
296 <td> </td>
297 <td> </td>
298 <td> </td>
299 </tr>
300 <tr>
301 <form action="purchase_report.php" method="post" name="purchase_report" target="_blank">
302 <td><strong>Purchase Report </strong></td>
303 <td>From</td>
304 <td><input name="from_purchase_date" type="text" id="from_purchase_date" style="width:80px;"></td>
305 <td>To</td>
306 <td><input name="to_purchase_date" type="text" id="to_purchase_date" style="width:80px;"></td>
307 <td><input name="submit" type="button" value="Show" onClick='purchase_report_fn();'></td>
308 </form>
309 </tr>
310 <tr>
311 <td> </td>
312 <td> </td>
313 <td> </td>
314 <td> </td>
315 <td> </td>
316 <td> </td>
317 </tr>
318 <tr>
319 <form action="sales_purchase_report.php" method="post" name="sales_purchase_report" target="_blank">
320 <td><strong>Purchase Stocks </strong></td>
321 <td>From</td>
322 <td><input name="from_sales_purchase_date" type="text" id="from_sales_purchase_date" style="width:80px;"></td>
323 <td>To</td>
324 <td><input name="to_sales_purchase_date" type="text" id="to_sales_purchase_date" style="width:80px;"></td>
325 <td><input name="submit" type="button" value="Show" onClick='sales_purchase_report_fn();'></td>
326 </form>
327 </tr>
328 <tr>
329 <td> </td>
330 <td> </td>
331 <td> </td>
332 <td> </td>
333 <td> </td>
334 <td> </td>
335 </tr>
336 <tr>
337 <td> </td>
338 <td> </td>
339 <td> </td>
340 <td> </td>
341 <td> </td>
342 <td> </td>
343 </tr>
344 <tr>
345 <td> </td>
346 <td> </td>
347 <td> </td>
348 <td> </td>
349 <td> </td>
350 <td> </td>
351 </tr>
352 <tr>
353 <td width="183">Total Number of Stocks </td>
354 <td width="84"><strong><?php echo $count = $db->countOfAll("stock_avail");?> </strong></td>
355 <td width="110">Payment Pending: </td>
356 <td width="110"><strong><?php
357
358 echo $db->queryUniqueValue("select sum(balance) FROM stock_entries where count1=1 and type='entry'");
359
360
361 ?></strong></td>
362 <td width="113"> </td>
363 <td width="113"> </td>
364 </tr>
365 <tr>
366 <td> </td>
367 <td> </td>
368 <td> </td>
369 <td> </td>
370 <td> </td>
371 <td> </td>
372 </tr>
373 <tr>
374 <td>Tatal Sales:</td>
375 <td><strong><?php echo $age = $db->queryUniqueValue("SELECT sum(subtotal) FROM stock_sales where count1=1 ");?></strong></td>
376 <td>Outstanding Amount: </td>
377 <td><strong><?php echo $db->queryUniqueValue("select sum(balance) FROM stock_sales where count1=1");
378 ?></strong></td>
379 <td> </td>
380 <td> </td>
381 </tr>
382 <tr>
383 <td> </td>
384 <td> </td>
385 <td> </td>
386 <td> </td>
387 <td> </td>
388 <td> </td>
389 </tr>
390 <tr>
391 <td>Total number of Suppliers </td>
392 <td><strong><?php echo $count = $db->countOfAll("supplier_details");?></strong></td>
393 <td>Total Number <br>
394 of Customers </td>
395 <td><strong><?php echo $count = $db->countOfAll("customer_details");?></strong></td>
396 <td> </td>
397 <td> </td>
398 </tr>
399 <tr>
400 <td> </td>
401 <td> </td>
402 <td> </td>
403 <td> </td>
404 <td> </td>
405 <td> </td>
406 </tr>
407 <tr>
408 <td> </td>
409 <td> </td>
410 <td> </td>
411 <td> </td>
412 <td> </td>
413 <td> </td>
414 </tr>
415 </table>
416 <br><br>
417 <br>
418 </td>
419 </tr>
420 </table>
421
422 </td>
423 </tr>
424 <tr>
425 <td height="30" align="center" bgcolor="#72C9F4"><span class="style1"><a href="http://www.pluskb.com">Developed by PlusKB Innovations</a></span></td>
426 </tr>
427 </table></td>
428 </tr>
429 </table></td>
430 </tr>
431 </table>
432
433 </body>
434 </html>
435 <?php
436 }
437 ?>